﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmDjkDiversionOrder" targetNamespace="http://tempuri.org/CDmDjkDiversionOrder.xsd" xmlns:mstns="http://tempuri.org/CDmDjkDiversionOrder.xsd" xmlns="http://tempuri.org/CDmDjkDiversionOrder.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dijiekeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dijiekeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.dijiekeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DJK_DIVERSION_ORDERTableAdapter" GeneratorDataComponentClassName="DJK_DIVERSION_ORDERTableAdapter" Name="DJK_DIVERSION_ORDER" UserDataComponentName="DJK_DIVERSION_ORDERTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dijiekeConnectionString (Settings)" DbObjectName="dijieke.dbo.DJK_DIVERSION_ORDER" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DJK_DIVERSION_ORDER] WHERE (([DIVERSION_ORDER_ID] = @Original_DIVERSION_ORDER_ID) AND ([ORDER_CODE] = @Original_ORDER_CODE) AND ([VEHICLE_ID] = @Original_VEHICLE_ID) AND ([TOURIST_NAME] = @Original_TOURIST_NAME) AND ([TOURIST_GENDER] = @Original_TOURIST_GENDER) AND ([ORDER_DEPOSIT] = @Original_ORDER_DEPOSIT) AND ([ORDER_TIME] = @Original_ORDER_TIME) AND ([ORDER_START_TIME] = @Original_ORDER_START_TIME) AND ([ORDER_STOP_TIME] = @Original_ORDER_STOP_TIME) AND ([TOURIST_PHONE] = @Original_TOURIST_PHONE) AND ([ORDER_STATUS] = @Original_ORDER_STATUS) AND ([ORDER_CREATE_USERID] = @Original_ORDER_CREATE_USERID) AND ([ORDER_UPDATE_USERID] = @Original_ORDER_UPDATE_USERID) AND ([ORDER_UPDATE_TIME] = @Original_ORDER_UPDATE_TIME) AND ([IS_DELETE] = @Original_IS_DELETE) AND ([ORDER_SOURCE_PLATFORM] = @Original_ORDER_SOURCE_PLATFORM) AND ([ORDER_PLATFORM_CODE] = @Original_ORDER_PLATFORM_CODE) AND ((@IsNull_DJACK_NAME = 1 AND [DJACK_NAME] IS NULL) OR ([DJACK_NAME] = @Original_DJACK_NAME)) AND ((@IsNull_DJACK_PHONE = 1 AND [DJACK_PHONE] IS NULL) OR ([DJACK_PHONE] = @Original_DJACK_PHONE)) AND ((@IsNull_DJACK_AGENT_NAME = 1 AND [DJACK_AGENT_NAME] IS NULL) OR ([DJACK_AGENT_NAME] = @Original_DJACK_AGENT_NAME)) AND ((@IsNull_ORDER_VEHICLE_NAME = 1 AND [ORDER_VEHICLE_NAME] IS NULL) OR ([ORDER_VEHICLE_NAME] = @Original_ORDER_VEHICLE_NAME)) AND ((@IsNull_ORDER_VEHICLE_NO = 1 AND [ORDER_VEHICLE_NO] IS NULL) OR ([ORDER_VEHICLE_NO] = @Original_ORDER_VEHICLE_NO)) AND ((@IsNull_ORDER_TOTAL_FEE = 1 AND [ORDER_TOTAL_FEE] IS NULL) OR ([ORDER_TOTAL_FEE] = @Original_ORDER_TOTAL_FEE)) AND ((@IsNull_DJACK_ID = 1 AND [DJACK_ID] IS NULL) OR ([DJACK_ID] = @Original_DJACK_ID)) AND ((@IsNull_ORDER_EXPIRE = 1 AND [ORDER_EXPIRE] IS NULL) OR ([ORDER_EXPIRE] = @Original_ORDER_EXPIRE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DIVERSION_ORDER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DIVERSION_ORDER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VEHICLE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TOURIST_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TOURIST_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TOURIST_GENDER" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TOURIST_GENDER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ORDER_DEPOSIT" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_DEPOSIT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_START_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_STOP_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_STOP_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TOURIST_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TOURIST_PHONE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ORDER_STATUS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ORDER_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_CREATE_USERID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CREATE_USERID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_UPDATE_USERID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_UPDATE_USERID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_UPDATE_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_UPDATE_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DELETE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ORDER_SOURCE_PLATFORM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ORDER_SOURCE_PLATFORM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_PLATFORM_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_PLATFORM_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_PHONE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_PHONE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_PHONE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_AGENT_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_AGENT_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_AGENT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_AGENT_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_TOTAL_FEE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_TOTAL_FEE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ORDER_TOTAL_FEE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_TOTAL_FEE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_EXPIRE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_EXPIRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_EXPIRE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_EXPIRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DJK_DIVERSION_ORDER] ([DIVERSION_ORDER_ID], [ORDER_CODE], [VEHICLE_ID], [TOURIST_NAME], [TOURIST_GENDER], [ORDER_DEPOSIT], [ORDER_TIME], [ORDER_START_TIME], [ORDER_STOP_TIME], [TOURIST_PHONE], [ORDER_STATUS], [ORDER_CREATE_USERID], [ORDER_UPDATE_USERID], [ORDER_UPDATE_TIME], [IS_DELETE], [ORDER_SOURCE_PLATFORM], [ORDER_PLATFORM_CODE], [DJACK_NAME], [DJACK_PHONE], [DJACK_AGENT_NAME], [ORDER_VEHICLE_NAME], [ORDER_VEHICLE_NO], [ORDER_TOTAL_FEE], [DJACK_ID], [ORDER_EXPIRE]) VALUES (@DIVERSION_ORDER_ID, @ORDER_CODE, @VEHICLE_ID, @TOURIST_NAME, @TOURIST_GENDER, @ORDER_DEPOSIT, @ORDER_TIME, @ORDER_START_TIME, @ORDER_STOP_TIME, @TOURIST_PHONE, @ORDER_STATUS, @ORDER_CREATE_USERID, @ORDER_UPDATE_USERID, @ORDER_UPDATE_TIME, @IS_DELETE, @ORDER_SOURCE_PLATFORM, @ORDER_PLATFORM_CODE, @DJACK_NAME, @DJACK_PHONE, @DJACK_AGENT_NAME, @ORDER_VEHICLE_NAME, @ORDER_VEHICLE_NO, @ORDER_TOTAL_FEE, @DJACK_ID, @ORDER_EXPIRE);
SELECT DIVERSION_ORDER_ID, ORDER_CODE, VEHICLE_ID, TOURIST_NAME, TOURIST_GENDER, ORDER_DEPOSIT, ORDER_TIME, ORDER_START_TIME, ORDER_STOP_TIME, TOURIST_PHONE, ORDER_STATUS, ORDER_CREATE_USERID, ORDER_UPDATE_USERID, ORDER_UPDATE_TIME, IS_DELETE, ORDER_SOURCE_PLATFORM, ORDER_PLATFORM_CODE, DJACK_NAME, DJACK_PHONE, DJACK_AGENT_NAME, ORDER_VEHICLE_NAME, ORDER_VEHICLE_NO, ORDER_TOTAL_FEE, DJACK_ID, ORDER_EXPIRE FROM DJK_DIVERSION_ORDER WHERE (DIVERSION_ORDER_ID = @DIVERSION_ORDER_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DIVERSION_ORDER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DIVERSION_ORDER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VEHICLE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TOURIST_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TOURIST_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TOURIST_GENDER" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TOURIST_GENDER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ORDER_DEPOSIT" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_DEPOSIT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_START_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_STOP_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_STOP_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TOURIST_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TOURIST_PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ORDER_STATUS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ORDER_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_CREATE_USERID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CREATE_USERID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_UPDATE_USERID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_UPDATE_USERID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_UPDATE_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_UPDATE_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DELETE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ORDER_SOURCE_PLATFORM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ORDER_SOURCE_PLATFORM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_PLATFORM_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_PLATFORM_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_AGENT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_AGENT_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_VEHICLE_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_VEHICLE_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ORDER_TOTAL_FEE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_TOTAL_FEE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_EXPIRE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_EXPIRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT DIVERSION_ORDER_ID, ORDER_CODE, VEHICLE_ID, TOURIST_NAME, TOURIST_GENDER, ORDER_DEPOSIT, ORDER_TIME, ORDER_START_TIME, ORDER_STOP_TIME, TOURIST_PHONE, ORDER_STATUS, ORDER_CREATE_USERID, ORDER_UPDATE_USERID, ORDER_UPDATE_TIME, IS_DELETE, ORDER_SOURCE_PLATFORM, ORDER_PLATFORM_CODE, DJACK_NAME, DJACK_PHONE, DJACK_AGENT_NAME, ORDER_VEHICLE_NAME, ORDER_VEHICLE_NO, ORDER_TOTAL_FEE, DJACK_ID, ORDER_EXPIRE FROM dbo.DJK_DIVERSION_ORDER</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DJK_DIVERSION_ORDER] SET [DIVERSION_ORDER_ID] = @DIVERSION_ORDER_ID, [ORDER_CODE] = @ORDER_CODE, [VEHICLE_ID] = @VEHICLE_ID, [TOURIST_NAME] = @TOURIST_NAME, [TOURIST_GENDER] = @TOURIST_GENDER, [ORDER_DEPOSIT] = @ORDER_DEPOSIT, [ORDER_TIME] = @ORDER_TIME, [ORDER_START_TIME] = @ORDER_START_TIME, [ORDER_STOP_TIME] = @ORDER_STOP_TIME, [TOURIST_PHONE] = @TOURIST_PHONE, [ORDER_STATUS] = @ORDER_STATUS, [ORDER_CREATE_USERID] = @ORDER_CREATE_USERID, [ORDER_UPDATE_USERID] = @ORDER_UPDATE_USERID, [ORDER_UPDATE_TIME] = @ORDER_UPDATE_TIME, [IS_DELETE] = @IS_DELETE, [ORDER_SOURCE_PLATFORM] = @ORDER_SOURCE_PLATFORM, [ORDER_PLATFORM_CODE] = @ORDER_PLATFORM_CODE, [DJACK_NAME] = @DJACK_NAME, [DJACK_PHONE] = @DJACK_PHONE, [DJACK_AGENT_NAME] = @DJACK_AGENT_NAME, [ORDER_VEHICLE_NAME] = @ORDER_VEHICLE_NAME, [ORDER_VEHICLE_NO] = @ORDER_VEHICLE_NO, [ORDER_TOTAL_FEE] = @ORDER_TOTAL_FEE, [DJACK_ID] = @DJACK_ID, [ORDER_EXPIRE] = @ORDER_EXPIRE WHERE (([DIVERSION_ORDER_ID] = @Original_DIVERSION_ORDER_ID) AND ([ORDER_CODE] = @Original_ORDER_CODE) AND ([VEHICLE_ID] = @Original_VEHICLE_ID) AND ([TOURIST_NAME] = @Original_TOURIST_NAME) AND ([TOURIST_GENDER] = @Original_TOURIST_GENDER) AND ([ORDER_DEPOSIT] = @Original_ORDER_DEPOSIT) AND ([ORDER_TIME] = @Original_ORDER_TIME) AND ([ORDER_START_TIME] = @Original_ORDER_START_TIME) AND ([ORDER_STOP_TIME] = @Original_ORDER_STOP_TIME) AND ([TOURIST_PHONE] = @Original_TOURIST_PHONE) AND ([ORDER_STATUS] = @Original_ORDER_STATUS) AND ([ORDER_CREATE_USERID] = @Original_ORDER_CREATE_USERID) AND ([ORDER_UPDATE_USERID] = @Original_ORDER_UPDATE_USERID) AND ([ORDER_UPDATE_TIME] = @Original_ORDER_UPDATE_TIME) AND ([IS_DELETE] = @Original_IS_DELETE) AND ([ORDER_SOURCE_PLATFORM] = @Original_ORDER_SOURCE_PLATFORM) AND ([ORDER_PLATFORM_CODE] = @Original_ORDER_PLATFORM_CODE) AND ((@IsNull_DJACK_NAME = 1 AND [DJACK_NAME] IS NULL) OR ([DJACK_NAME] = @Original_DJACK_NAME)) AND ((@IsNull_DJACK_PHONE = 1 AND [DJACK_PHONE] IS NULL) OR ([DJACK_PHONE] = @Original_DJACK_PHONE)) AND ((@IsNull_DJACK_AGENT_NAME = 1 AND [DJACK_AGENT_NAME] IS NULL) OR ([DJACK_AGENT_NAME] = @Original_DJACK_AGENT_NAME)) AND ((@IsNull_ORDER_VEHICLE_NAME = 1 AND [ORDER_VEHICLE_NAME] IS NULL) OR ([ORDER_VEHICLE_NAME] = @Original_ORDER_VEHICLE_NAME)) AND ((@IsNull_ORDER_VEHICLE_NO = 1 AND [ORDER_VEHICLE_NO] IS NULL) OR ([ORDER_VEHICLE_NO] = @Original_ORDER_VEHICLE_NO)) AND ((@IsNull_ORDER_TOTAL_FEE = 1 AND [ORDER_TOTAL_FEE] IS NULL) OR ([ORDER_TOTAL_FEE] = @Original_ORDER_TOTAL_FEE)) AND ((@IsNull_DJACK_ID = 1 AND [DJACK_ID] IS NULL) OR ([DJACK_ID] = @Original_DJACK_ID)) AND ((@IsNull_ORDER_EXPIRE = 1 AND [ORDER_EXPIRE] IS NULL) OR ([ORDER_EXPIRE] = @Original_ORDER_EXPIRE)));
SELECT DIVERSION_ORDER_ID, ORDER_CODE, VEHICLE_ID, TOURIST_NAME, TOURIST_GENDER, ORDER_DEPOSIT, ORDER_TIME, ORDER_START_TIME, ORDER_STOP_TIME, TOURIST_PHONE, ORDER_STATUS, ORDER_CREATE_USERID, ORDER_UPDATE_USERID, ORDER_UPDATE_TIME, IS_DELETE, ORDER_SOURCE_PLATFORM, ORDER_PLATFORM_CODE, DJACK_NAME, DJACK_PHONE, DJACK_AGENT_NAME, ORDER_VEHICLE_NAME, ORDER_VEHICLE_NO, ORDER_TOTAL_FEE, DJACK_ID, ORDER_EXPIRE FROM DJK_DIVERSION_ORDER WHERE (DIVERSION_ORDER_ID = @DIVERSION_ORDER_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DIVERSION_ORDER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DIVERSION_ORDER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VEHICLE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TOURIST_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TOURIST_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TOURIST_GENDER" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TOURIST_GENDER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ORDER_DEPOSIT" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_DEPOSIT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_START_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_STOP_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_STOP_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TOURIST_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TOURIST_PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ORDER_STATUS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ORDER_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_CREATE_USERID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CREATE_USERID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_UPDATE_USERID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_UPDATE_USERID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_UPDATE_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_UPDATE_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DELETE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ORDER_SOURCE_PLATFORM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ORDER_SOURCE_PLATFORM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_PLATFORM_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_PLATFORM_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_AGENT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_AGENT_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_VEHICLE_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_VEHICLE_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ORDER_TOTAL_FEE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_TOTAL_FEE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_EXPIRE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_EXPIRE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DIVERSION_ORDER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DIVERSION_ORDER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VEHICLE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VEHICLE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TOURIST_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TOURIST_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TOURIST_GENDER" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TOURIST_GENDER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ORDER_DEPOSIT" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_DEPOSIT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_START_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_STOP_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_STOP_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TOURIST_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TOURIST_PHONE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ORDER_STATUS" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ORDER_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_CREATE_USERID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CREATE_USERID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_UPDATE_USERID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_UPDATE_USERID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_UPDATE_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_UPDATE_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_DELETE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DELETE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ORDER_SOURCE_PLATFORM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ORDER_SOURCE_PLATFORM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_PLATFORM_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_PLATFORM_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_PHONE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_PHONE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_PHONE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_AGENT_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_AGENT_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_AGENT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_AGENT_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_VEHICLE_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_VEHICLE_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_VEHICLE_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_TOTAL_FEE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_TOTAL_FEE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ORDER_TOTAL_FEE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_TOTAL_FEE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_EXPIRE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_EXPIRE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_EXPIRE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_EXPIRE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DIVERSION_ORDER_ID" DataSetColumn="DIVERSION_ORDER_ID" />
              <Mapping SourceColumn="ORDER_CODE" DataSetColumn="ORDER_CODE" />
              <Mapping SourceColumn="VEHICLE_ID" DataSetColumn="VEHICLE_ID" />
              <Mapping SourceColumn="TOURIST_NAME" DataSetColumn="TOURIST_NAME" />
              <Mapping SourceColumn="TOURIST_GENDER" DataSetColumn="TOURIST_GENDER" />
              <Mapping SourceColumn="ORDER_DEPOSIT" DataSetColumn="ORDER_DEPOSIT" />
              <Mapping SourceColumn="ORDER_TIME" DataSetColumn="ORDER_TIME" />
              <Mapping SourceColumn="ORDER_START_TIME" DataSetColumn="ORDER_START_TIME" />
              <Mapping SourceColumn="ORDER_STOP_TIME" DataSetColumn="ORDER_STOP_TIME" />
              <Mapping SourceColumn="TOURIST_PHONE" DataSetColumn="TOURIST_PHONE" />
              <Mapping SourceColumn="ORDER_STATUS" DataSetColumn="ORDER_STATUS" />
              <Mapping SourceColumn="ORDER_CREATE_USERID" DataSetColumn="ORDER_CREATE_USERID" />
              <Mapping SourceColumn="ORDER_UPDATE_USERID" DataSetColumn="ORDER_UPDATE_USERID" />
              <Mapping SourceColumn="ORDER_UPDATE_TIME" DataSetColumn="ORDER_UPDATE_TIME" />
              <Mapping SourceColumn="IS_DELETE" DataSetColumn="IS_DELETE" />
              <Mapping SourceColumn="ORDER_SOURCE_PLATFORM" DataSetColumn="ORDER_SOURCE_PLATFORM" />
              <Mapping SourceColumn="ORDER_PLATFORM_CODE" DataSetColumn="ORDER_PLATFORM_CODE" />
              <Mapping SourceColumn="DJACK_NAME" DataSetColumn="DJACK_NAME" />
              <Mapping SourceColumn="DJACK_PHONE" DataSetColumn="DJACK_PHONE" />
              <Mapping SourceColumn="DJACK_AGENT_NAME" DataSetColumn="DJACK_AGENT_NAME" />
              <Mapping SourceColumn="ORDER_VEHICLE_NAME" DataSetColumn="ORDER_VEHICLE_NAME" />
              <Mapping SourceColumn="ORDER_VEHICLE_NO" DataSetColumn="ORDER_VEHICLE_NO" />
              <Mapping SourceColumn="ORDER_TOTAL_FEE" DataSetColumn="ORDER_TOTAL_FEE" />
              <Mapping SourceColumn="DJACK_ID" DataSetColumn="DJACK_ID" />
              <Mapping SourceColumn="ORDER_EXPIRE" DataSetColumn="ORDER_EXPIRE" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmDjkDiversionOrder" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmDjkDiversionOrder" msprop:Generator_UserDSName="CDmDjkDiversionOrder">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DJK_DIVERSION_ORDER" msprop:Generator_TableClassName="DJK_DIVERSION_ORDERDataTable" msprop:Generator_TableVarName="tableDJK_DIVERSION_ORDER" msprop:Generator_TablePropName="DJK_DIVERSION_ORDER" msprop:Generator_RowDeletingName="DJK_DIVERSION_ORDERRowDeleting" msprop:Generator_RowChangingName="DJK_DIVERSION_ORDERRowChanging" msprop:Generator_RowEvHandlerName="DJK_DIVERSION_ORDERRowChangeEventHandler" msprop:Generator_RowDeletedName="DJK_DIVERSION_ORDERRowDeleted" msprop:Generator_UserTableName="DJK_DIVERSION_ORDER" msprop:Generator_RowChangedName="DJK_DIVERSION_ORDERRowChanged" msprop:Generator_RowEvArgName="DJK_DIVERSION_ORDERRowChangeEvent" msprop:Generator_RowClassName="DJK_DIVERSION_ORDERRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DIVERSION_ORDER_ID" msprop:Generator_ColumnVarNameInTable="columnDIVERSION_ORDER_ID" msprop:Generator_ColumnPropNameInRow="DIVERSION_ORDER_ID" msprop:Generator_ColumnPropNameInTable="DIVERSION_ORDER_IDColumn" msprop:Generator_UserColumnName="DIVERSION_ORDER_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_CODE" msprop:Generator_ColumnVarNameInTable="columnORDER_CODE" msprop:Generator_ColumnPropNameInRow="ORDER_CODE" msprop:Generator_ColumnPropNameInTable="ORDER_CODEColumn" msprop:Generator_UserColumnName="ORDER_CODE">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VEHICLE_ID" msprop:Generator_ColumnVarNameInTable="columnVEHICLE_ID" msprop:Generator_ColumnPropNameInRow="VEHICLE_ID" msprop:Generator_ColumnPropNameInTable="VEHICLE_IDColumn" msprop:Generator_UserColumnName="VEHICLE_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TOURIST_NAME" msprop:Generator_ColumnVarNameInTable="columnTOURIST_NAME" msprop:Generator_ColumnPropNameInRow="TOURIST_NAME" msprop:Generator_ColumnPropNameInTable="TOURIST_NAMEColumn" msprop:Generator_UserColumnName="TOURIST_NAME">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TOURIST_GENDER" msprop:Generator_ColumnVarNameInTable="columnTOURIST_GENDER" msprop:Generator_ColumnPropNameInRow="TOURIST_GENDER" msprop:Generator_ColumnPropNameInTable="TOURIST_GENDERColumn" msprop:Generator_UserColumnName="TOURIST_GENDER" type="xs:boolean" />
              <xs:element name="ORDER_DEPOSIT" msprop:Generator_ColumnVarNameInTable="columnORDER_DEPOSIT" msprop:Generator_ColumnPropNameInRow="ORDER_DEPOSIT" msprop:Generator_ColumnPropNameInTable="ORDER_DEPOSITColumn" msprop:Generator_UserColumnName="ORDER_DEPOSIT" type="xs:decimal" />
              <xs:element name="ORDER_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_TIMEColumn" msprop:Generator_UserColumnName="ORDER_TIME" type="xs:dateTime" />
              <xs:element name="ORDER_START_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_START_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_START_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_START_TIMEColumn" msprop:Generator_UserColumnName="ORDER_START_TIME" type="xs:dateTime" />
              <xs:element name="ORDER_STOP_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_STOP_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_STOP_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_STOP_TIMEColumn" msprop:Generator_UserColumnName="ORDER_STOP_TIME" type="xs:dateTime" />
              <xs:element name="TOURIST_PHONE" msprop:Generator_ColumnVarNameInTable="columnTOURIST_PHONE" msprop:Generator_ColumnPropNameInRow="TOURIST_PHONE" msprop:Generator_ColumnPropNameInTable="TOURIST_PHONEColumn" msprop:Generator_UserColumnName="TOURIST_PHONE">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_STATUS" msprop:Generator_ColumnVarNameInTable="columnORDER_STATUS" msprop:Generator_ColumnPropNameInRow="ORDER_STATUS" msprop:Generator_ColumnPropNameInTable="ORDER_STATUSColumn" msprop:Generator_UserColumnName="ORDER_STATUS" type="xs:short" />
              <xs:element name="ORDER_CREATE_USERID" msprop:Generator_ColumnVarNameInTable="columnORDER_CREATE_USERID" msprop:Generator_ColumnPropNameInRow="ORDER_CREATE_USERID" msprop:Generator_ColumnPropNameInTable="ORDER_CREATE_USERIDColumn" msprop:Generator_UserColumnName="ORDER_CREATE_USERID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_UPDATE_USERID" msprop:Generator_ColumnVarNameInTable="columnORDER_UPDATE_USERID" msprop:Generator_ColumnPropNameInRow="ORDER_UPDATE_USERID" msprop:Generator_ColumnPropNameInTable="ORDER_UPDATE_USERIDColumn" msprop:Generator_UserColumnName="ORDER_UPDATE_USERID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_UPDATE_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_UPDATE_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_UPDATE_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_UPDATE_TIMEColumn" msprop:Generator_UserColumnName="ORDER_UPDATE_TIME" type="xs:dateTime" />
              <xs:element name="IS_DELETE" msprop:Generator_ColumnVarNameInTable="columnIS_DELETE" msprop:Generator_ColumnPropNameInRow="IS_DELETE" msprop:Generator_ColumnPropNameInTable="IS_DELETEColumn" msprop:Generator_UserColumnName="IS_DELETE" type="xs:boolean" />
              <xs:element name="ORDER_SOURCE_PLATFORM" msprop:Generator_ColumnVarNameInTable="columnORDER_SOURCE_PLATFORM" msprop:Generator_ColumnPropNameInRow="ORDER_SOURCE_PLATFORM" msprop:Generator_ColumnPropNameInTable="ORDER_SOURCE_PLATFORMColumn" msprop:Generator_UserColumnName="ORDER_SOURCE_PLATFORM" type="xs:short" />
              <xs:element name="ORDER_PLATFORM_CODE" msprop:Generator_ColumnVarNameInTable="columnORDER_PLATFORM_CODE" msprop:Generator_ColumnPropNameInRow="ORDER_PLATFORM_CODE" msprop:Generator_ColumnPropNameInTable="ORDER_PLATFORM_CODEColumn" msprop:Generator_UserColumnName="ORDER_PLATFORM_CODE">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DJACK_NAME" msprop:Generator_ColumnVarNameInTable="columnDJACK_NAME" msprop:Generator_ColumnPropNameInRow="DJACK_NAME" msprop:Generator_ColumnPropNameInTable="DJACK_NAMEColumn" msprop:Generator_UserColumnName="DJACK_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DJACK_PHONE" msprop:Generator_ColumnVarNameInTable="columnDJACK_PHONE" msprop:Generator_ColumnPropNameInRow="DJACK_PHONE" msprop:Generator_ColumnPropNameInTable="DJACK_PHONEColumn" msprop:Generator_UserColumnName="DJACK_PHONE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DJACK_AGENT_NAME" msprop:Generator_ColumnVarNameInTable="columnDJACK_AGENT_NAME" msprop:Generator_ColumnPropNameInRow="DJACK_AGENT_NAME" msprop:Generator_ColumnPropNameInTable="DJACK_AGENT_NAMEColumn" msprop:Generator_UserColumnName="DJACK_AGENT_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_VEHICLE_NAME" msprop:Generator_ColumnVarNameInTable="columnORDER_VEHICLE_NAME" msprop:Generator_ColumnPropNameInRow="ORDER_VEHICLE_NAME" msprop:Generator_ColumnPropNameInTable="ORDER_VEHICLE_NAMEColumn" msprop:Generator_UserColumnName="ORDER_VEHICLE_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_VEHICLE_NO" msprop:Generator_ColumnVarNameInTable="columnORDER_VEHICLE_NO" msprop:Generator_ColumnPropNameInRow="ORDER_VEHICLE_NO" msprop:Generator_ColumnPropNameInTable="ORDER_VEHICLE_NOColumn" msprop:Generator_UserColumnName="ORDER_VEHICLE_NO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_TOTAL_FEE" msprop:Generator_ColumnVarNameInTable="columnORDER_TOTAL_FEE" msprop:Generator_ColumnPropNameInRow="ORDER_TOTAL_FEE" msprop:Generator_ColumnPropNameInTable="ORDER_TOTAL_FEEColumn" msprop:Generator_UserColumnName="ORDER_TOTAL_FEE" type="xs:decimal" minOccurs="0" />
              <xs:element name="DJACK_ID" msprop:Generator_ColumnVarNameInTable="columnDJACK_ID" msprop:Generator_ColumnPropNameInRow="DJACK_ID" msprop:Generator_ColumnPropNameInTable="DJACK_IDColumn" msprop:Generator_UserColumnName="DJACK_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_EXPIRE" msprop:Generator_ColumnVarNameInTable="columnORDER_EXPIRE" msprop:Generator_ColumnPropNameInRow="ORDER_EXPIRE" msprop:Generator_ColumnPropNameInTable="ORDER_EXPIREColumn" msprop:Generator_UserColumnName="ORDER_EXPIRE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="800" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DJK_DIVERSION_ORDER" />
      <xs:field xpath="mstns:DIVERSION_ORDER_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>